Round 1 - Technical (90 minutes)

The questions asked in this round included:

🔹 What are the main components of Azure Data Factory?

🔹 Different types of Integration Runtimes in ADF.

🔹 Explain Data Flows in ADF.

🔹 How to connect a Databricks notebook to ADF.

🔹 How to automate a stored procedure in an ADF pipeline.

🔹 How to integrate ADF with CI/CD.

🔹 Differences between temporary tables and views.

🔹 How do you handle errors and exceptions in T-SQL?

🔹 Differences between clustered and non-clustered indexes.

🔹 SQL query optimization techniques.

🔹 What is a CTE (Common Table Expression) in SQL?

🔹 Explain the `APPLY` operator in SQL and its types.

🔹 What is the `PIVOT` operator in T-SQL?

🔹 Explain normalization and the three normal forms with examples.

🔹 Commonly used big data processing services in Azure and details about each.

🔹 Explain the Schema-on-Read approach with examples.

🔹 What does Schema Evolution mean?

🔹 Common scenarios in big data processing and the appropriate approaches and tools.

🔹 Key features of Databricks.

🔹 How to integrate Databricks with Data Lake.

🔹 Advantages of Delta Lake.

🔹 Explain the Medallion architecture in detail.

🔹 How do you configure resources in Databricks?

🔹 Explain RBAC (Role-Based Access Control) in Databricks.

🔹 Types of caching in Snowflake.

🔹 Advantages of the Time Travel feature in Snowflake.

🔹 Differences between Fail-safe and Time Travel features in Snowflake.

🔹 Key features of Snowflake data sharing.

🔹 What is Snowpipe, and can we pull data from an API and ingest it into Snowflake?

🔹 What are materialized views?

🔹 Common Python libraries used for data engineering.

🔹 Explain the usage of `break`, `continue`, and `pass` in Python.

🔹 What is the function to rename columns in pandas?

🔹 Explain different data types in Python.

🔹 How to convert a pandas DataFrame to Excel?

🔹 Explain GIL (Global Interpreter Lock) in Python.

🔹 How to pass an API response to a DataFrame?

🔹 How to store a DataFrame in Azure Storage?

🔹 Explain the Lambda function in Python.

🔹 Explain the negative indexing feature in Python.

🔹 Explain iterators, decorators, and generators in Python.

🔹 Explain pickling and unpickling in Python.

🔹 Differences between `range` and `xrange`.

🔹 Differences between shallow copy and deep copy.

Round 2 - Techno-Managerial

This round was taken by a director-level executive and focused mainly on project discussions and cross-questioning related to Azure projects for about 10-15 minutes. There were also some questions on SCD (Slowly Changing Dimensions) types in Snowflake and a few general questions.

Round 3 - HR Discussion

🔹Salary Negotiation.

🔹Variable component discussion.

I did not proceed to the HR discussion due to disagreements on salary compensation.